Printing an Inventory Transactions Report

When you enter the Inventory Transactions Report option the report will generate automatically. Command options will appear allowing you to print or choose from a set of other print options.

The report prints the following:

• Grp – The item group ID code
• Item Name – The name of the item and the type of inventory transactions associated with the item. Inventory transaction types are:
• Sale – Sales order
• Credit – Credit order
• Inventory adjustments – The cost adjustment type will be displayed in this field
• Adjustment – Weight only adjustment, no value adjustment
• Transfers in
• Transfers out
• Hold Purchase Order – Hold Purchase Orders are purchases entered through Purchase Orders and received through Receiving Purchase Orders, but not yet completed, and therefore, still on hold.
• Hold Purchasing – Hold Purchasing indicates the product was received and completed on inventory hold.
• Purchase – Purchase order
• WO (work order) Raw Material
• WO Dry Good
• WO Finished Good

• Vendor/Cust – The vendor from whom the item was purchased; or the customer to whom this item was sold. A blank or "//////" indicates that the vendor identity has been lost, due to the combination of multiple lots from multiple vendors.
• Ref # – The transaction reference number for the shipped sales orders, credit orders added back to inventory, received purchase orders, transfers, planned transfers, inventory adjustments, and work orders for the current date.

• Cost/Price – The per unit cost at which this item was purchased, or the per unit price at which this item was sold. Inventory adjustments display as the total net change of the valuation of the item.
• Un – The invoicing unit of measure. This is the unit of measure in which the Cost/Price is stated.
• Quantity – The total quantity of the inventory transaction. Sale, Transfer Out, WO Raw Material, and WO Dry Good display as negative quantities, as all of these transactions subtract from inventory. Credit added back to inventory, Purchase, Transfer In, and WO Finished Goods, display as positive quantities, as all of these transactions add into inventory. Inventory adjustments and weight adjustments may be positive or negative.

Note: The current on hand amount (On Hand Now) will always be listed on the first line of the display for each item.

• Un – The stocking unit of measure. This is the unit of measure in which the quantity is stated.
• Date – The date on which this transaction occurred. The on-hand amount for the date of the inquiry (inventory on DD/MM) will be listed as the last line for each item.

For more information on the Inventory Transactions Report see Inventory Transactions Report.

Security Required : Inventory - Inventory Reports